SHEETNAME
Returns the name
of a specified sheet in the current workbook.
Syntax
SHEETNAME(sheet_num)
sheet_num
- the index number of the sheet (in the current workbook) to be considered.
For example, the first sheet (count from the left) is 1, and so on.
Remarks
- You can specify
a cell (cell reference) that contains a number, a logical values, or text
representations of numbers. Cells that contain error values or text that cannot
be translated into numbers cause errors.
- sheet_num must
be larger than or equal to zero.
- If sheet_num
is not a whole number, then it is rounded to the nearest integer.
- If sheet_num
is 0 (zero), SHEETNAME returns the name of the current worksheet.
- If sheet_num
is larger than the total number of sheets in the current workbook, SHEETNAME
returns a #VALUE! error.
[
©2000-2001, Edwin H. B. Tam, All rights reserved ]